package com.hooya.fa.eu.biz.dao.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.hooya.fa.eu.api.vo.SaleOrderPackageVO;
import com.hooya.fa.eu.api.vo.XsReportInfoVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Set;

/**
 * @Description 1
 * @Author : Zongz
 * @Copyright Copyright (c) 豪雅集团
 * @Create 2024/2/6
 * @Version 1.0.0
 */
@Mapper
public interface OrderReturnedMapper {

    /**
     * 根据时间获取退货订单id
     *
     * @param startDate
     * @param endDate
     * @return
     */
    List<String> getReturnedOrderIdsByDate(@Param("startDate") String startDate, @Param("endDate") CharSequence endDate);

	@DS("order_eu")
	List<String> getReturnedOrderIdsByDateDaily(@Param("startDate") String startDate, @Param("endDate") CharSequence endDate);

    /**
     * 获取销售报表信息【正常订单】
     *
     * @param sheetNumberList
     * @return
     */
    List<XsReportInfoVO> getXsReportInfoList(@Param("sheetNumberList") List<String> sheetNumberList);

    /**
     * 根据sheetNumber 获取 LogisticsIdMap
     *
     * @param sheetNumberList
     * @return
     */
    List<SaleOrderPackageVO> getLogisticsIdMapBySheetNumber(@Param("sheetNumberList") Set<String> sheetNumberList);

    /**
     * 获取销售报表信息【可能该sheetNumber是重发/补发情况】
     *
     * @param sheetNumberList
     * @return
     */
    List<XsReportInfoVO> getXsReportInfoOtherList(@Param("sheetNumberList") List<String> sheetNumberList);
}
